begin transaction SchemaUpdate
print 'transaction "SchemaUpdate" started'

begin try
	
	alter table [Group]
	add [LCID] nvarchar(4) null
	print 'LCID added to "Group"'
	
	commit transaction SchemaUpdate
	print 'transaction "SchemaUpdate" committed'		
	
end try
begin catch	
	rollback transaction SchemaUpdate
	print 'transaction "SchemaUpdate" rolled back'		
end catch
go
			
begin transaction DataUpdate
begin try
	
	update [Group]
	set LCID = '1031'
	print 'set 1031 as LCID for all groups'

	alter table [Group]
	alter column LCID nvarchar(4) not null
	print 'set LCID in table Group "not null"'

	update [Version]
	set VersionNr = '1.6'
	print 'VersionNr updated to 1.6'
	
	commit transaction DataUpdate
	print 'transaction "DataUpdate" committed'
end try
begin catch
	rollback transaction DataUpdate
	print 'transaction "DataUpdate" rolled back'
end catch